<?php
	header("Content-type: text/html; charset=utf-8");
	require 'config.inc.php';
	function __autoload($class_name)
	{
		include 'class/' . strtolower($class_name) . '.class.php';
	}


	$db = new DB(DSN, DB_USER, DB_PASSWORD);
	// $results = $db->noneParamQuery('select* from message');
	echo '<pre>';

	// $results = $db->getNextLineData();
	// $db->execSQL('insert into `message` values()');, array(':user_name'=>'gps', ':time'=>'2017-1-1', ':notes'=>'this is a test')
	// $result = $db->paramNoneQuery("insert into `message`(`user_name`, `time`, `notes`) values(':user_name', ':time', ':notes')", array(':user_name'=>'gps', ':time'=>'2017-1-1', ':notes'=>'this is a test'), false);
	// $result = $db->paramQuery("select* from `message` where user_name=`:user_name`", array(':user_name'=>'gps'), false);
	// $result = $db->noneQuery("insert into `message`(`user_name`, `time`, `notes`) values(:user_name, :time, :notes)", array(':user_name'=>'uu', ':time'=>'2018-7-7', ':notes'=>'this is a test~'));
	$result = $db->query("select* from message");

	var_dump($result);


	echo '</pre>';
